package com.kandinfo.survey.common.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.kandinfo.base.common.repository.BaseRepository;
import com.kandinfo.survey.common.domain.QuestionnaireInfo;

public interface QuestionnaireInfoRepository extends BaseRepository<QuestionnaireInfo, Long> {

    @Query(value = "select * from questionnaire_info where name like '%?2%' and dest_Type=?1 and status='1'", nativeQuery = true)
    List<QuestionnaireInfo> findQuestionnaire(int destType, String name);

}
